Create TRIGGER [dbo].[ForEShopUnit1]
ON [dbo].[Unit1]
AFTER INSERT, DELETE, UPDATE
AS
    BEGIN
        SET NOCOUNT ON;
        IF EXISTS (   SELECT *
                          FROM   Inserted )
            INSERT dbo.EShopTablesChanges ( Id ,
                                            Name ,
                                            EntityRowId ,
                                            ModifiedOn ,
                                            Action )
                   SELECT NEWID() ,
                          'Unit1' ,
                          Inserted.Id ,
                          GETDATE() ,
                          0
                   FROM   Inserted
        ELSE IF EXISTS (   SELECT *
                               FROM   Deleted )
            INSERT dbo.EShopTablesChanges ( Id ,
                                            Name ,
                                            EntityRowId ,
                                            ModifiedOn ,
                                            Action )
                   SELECT NEWID() ,
                          'Unit1' ,
                          Deleted.Id ,
                          GETDATE() ,
                          1
                   FROM   Deleted

    END